Reducing Multidimensional Data
نویسندگان
چکیده
Our aim is to elaborate a multidimensional database reduction process which will specify aggregated schema applicable over a period of time as well as retains useful data for decision support. Firstly, we describe a multidimensional database schema composed of a set of states. Each state is defined as a star schema composed of one fact and its related dimensions. Each reduced state is defined through reduction operators. Secondly, we describe our experiments and discuss their results. Evaluating our solution implies executing different requests in various contexts: unreduced single fact table, unreduced relational star schema, reduced star schema or reduced snowflake schema. We show that queries are more efficiently calculated within a reduced star schema.
منابع مشابه
Triangular Visualization
The TriVis algorithm for visualization of multidimensional data proximities in two dimensions is presented. The algorithm preserves maximum number of exact distances, has simple interpretation, and unlike multidimensional scaling (MDS) does not require costly minimization. It may also provide an excellent starting point significantly reducing the number of required iterations in MDS.
متن کاملScalable Dimension Reduction for Large Abstract Data Visualization
The ability to browse vast amounts of scientific data is critical to facilitate science discovery. High performance Multidimensional Scaling (MDS) algorithm makes it a reality by reducing dimensions so that scientists can gain insight into data set from a 3D visualization space. As multidimensional scaling requires quadratics order of physical memory and computation, a major challenge is to des...
متن کاملUsage of Dissimilarity Measures and Multidimensional Scaling for Large Scale Solar Data Analysis
This work describes the application of several dissimilarity measures combined with multidimensional scaling for large scale solar data analysis. Using the first solar domain-specific benchmark data set that contains multiple types of phenomena, we investigated combinations of different image parameters with different dissimilarity measures in order to determine which combinations will allow us...
متن کاملA Framework for Reducing Multidimensional Database to Two Dimensions
This work used a method of Matrix Decomposition Algorithm to obtain a new dataset of genetic epistasis as a surrogate for a multidimensional dataset which transformed multidimensional database to a 2dimensional database. It employed decomposition algorithms based on Boyce Codd Normal Form for minimizing anomalies. The decomposition and reversible algorithms were used on relationship among objec...
متن کاملاثربخشی برنامه خودمدیریتی شناختی برکاهش پرخاشگری و علائم چندوجهی درد زنان مبتلا به درد مزمن
Aim and background:Chronic pain is an important public health problem that seriously affects people’s everyday lives. Aggression has been widely observed in patients with chronic pains and several studies have suggested that aggression is highly associated with chronic pain intensity. The aim of the current study was to test the effectiveness of cognitive self-management program in reducing ag...
متن کاملStorage of Multidimensional Arrays Based on Arbitrary Tiling
Storage management of multidimensional arrays aims at supporting the array model needed by applications and insuring fast execution of access operations. Current approaches to store multidimensional arrays rely on partitioning data into chunks (equally sized subarrays). Regular partitioning, however, does not adapt to access patterns, leading to suboptimal access performance. In this paper, we ...
متن کامل